StoreSafeTender

Entity Definition

Logical Name : StoreSafeTender
Physical Name : LE_TND_STR_SF

A current, running total of tender loans, tender pickups, deposits, receipts and other monetary values and counts accumulated from tender control transactions. This running set of totals is cleared to zero upon completion of a SAFE settlement transaction process.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SafeID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Safe(AS_SF)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
OpenMediaUnitQuantity The opening number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the TILL before closing a till settlement period. QU_OPN_MD_QTY QuantityInteger integer
CloseBalanceAmount The closing system maintained tender balance in the SAFE before formalizing the closing of a safe settlement period. MO_CL_BLNC_AMT Money decimal(16,5)
CloseMediaUnitQuantity The closing number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. QU_CL_MD_UN QuantityInteger integer
CountedBalanceAmount The counted tender balance in the SAFE before the fomal closing of a safe settlement period. The counted balance represents the manually counted amount that is compared to the closing balance to determine over/under variance in tender at the end of a till settlement period. MO_CNT_BLNC_AMT Money decimal(16,5)
CountedMediaUnitQuantity The counted number of discrete tender media (e.g. currency bills, coins, credit/debit card signed slips, etc.) in the SAFE before the formal closing of a safe settlement period. QU_CNT_MD_UN QuantityInteger integer
OverUnderBalanceAmount The variance between closing balance amount and counted balance amount before the formal closing of a safe settlement period calculated by subtracting the CountedBalanceAmount from the CloseBalanceAmount A POSITIVE variance means that there is an under variance where the CLOSE balance is higher than the COUNTED balance. A NEGATIVE variance means there is an over variance where the CLOSE balance is less than the COUNTED balance (extra tender) MO_OVR_UND_BLNC_AMT Money decimal(16,5)
OverUnderMediaUnitQuantity The variance between closing media unit quantity and counted media unit quantity before the closing of a safe settlement period calculated by subtracting the CountedMediaUnitQuantity from the CloseMediaUnitQuantity. A POSITIVE variance means that there is an under variance where the CLOSE media unit quantity is higher than the COUNTED media unit quantity A NEGATIVE variance means there is an over variance where the CLOSE media unit quantity is less than the COUNTED media unit quantity (extra tender) QU_OVR_UND_MD_UN QuantityInteger integer
PickupFromTillAmount The running sum of tender amount picked up from tills and received into this SAFE during the safe settlement period before formally closing the period. MO_PKP_FR_TL_AMT Money decimal(16,5)
PickupFromTillMediaUnitQuantity The running sum of tender media unit counts picked up from tills and received into this SAFE during the safe settlement period before formally closing that period. QU_PKP_FR_TL_MD_UN QuantityInteger integer
LoanToTillAmount The running sum of tender amounts loaned to tills from this SAFE during the safe settlement period before formally closing that period. MO_LON_TO_TL_AMT Money decimal(16,5)
LoanToTillMediaUnitQuantity The running sum of tender media unit counts loaned to tills from this SAFE during the safe settlement period before formally closing that period. QU_LON_TO_TL_MD_UN QuantityInteger integer
DepositToTenderDespositoryAmount The running sum of tender amount deposited to an external tender depository (bank) during the safe settlement period prior to closing the period. MO_DS_TO_TND_DSY_AMT Money decimal(16,5)
DepositToTenderDepositoryMediaUnitQuantity The running sum of tender unit quantity deposited to an external tender depository (bank) during the safe settlement period before closing that period. QU_DS_TO_TND_DSY_MD_UN QuantityInteger integer
ReceiptFromTenderDepositoryAmount The running sum of the tender amount received from an external depository (through one or more withdrawals) during a SAFE settlement period prior to the formal end of that period. This represents money withdrawn from a bank to maintain sufficient onhand cash in a store to make change and pay cash to vendors. MO_RCT_FM_TND_DSY_AMT Money decimal(16,5)
ReceiptFromTenderDepositoryUnitQuantity The running total tender media unit count brought IN to a SAFE for a safe settlement period prior to the formal end of that period. QU_RCPT_FM_TND_DSY_MD_UN QuantityInteger integer
DisbursementAmount Running total of tender disbursements made from this SAFE during the safe settlement period prior to the formal end of that period. Note ARTS allows retailers to capture disbursements made at the till level (through the POS) or at the safe level (through the back office system). Retailers may use procedural logic to limit how disbursements are handled. MO_DSB_AMT Money decimal(16,5)
DisbursementMediaUnitQuantity Running total tender disbursement media units made from this SAFE during the safe settlement period prior to the end of that period Note ARTS allows retailers to capture disbursements made at the till level (through the POS) or at the safe level (through the back office system). Retailers may use procedural logic to limit how disbursements are handled. QU_DSB_MD_UN QuantityInteger integer
FundsReceiptAmount Running sum of tender amount received from non retail transaction and non-till pickups during a safe settlement period prior to the closing of that period. This receipt is a misc. inflow of tender that is not related to a retail transaction or a till pick up or bank. MO_FND_RCT_AMT Money decimal(16,5)
FundsReceiptMediaUnitQuantity Running sum of tender media unit quantity received from non retail transaction and non-till pickups during a safe settlement period prior to the formal close of that period. QU_FND_RCPT_MD_UN QuantityInteger integer
SafeTransferAmount The running sum of tender amount transferred between store safes during a safet settlement period prior to the formal closing of that period. This value is one safe's portion of the transfer summary. MO_SF_TSF_AMT Money decimal(16,5)
SafeTransferMediaUnitQuantity The running sum of tender amount transferred between store safes during a safe settlement period prior to the formal closing of that period. This value is one safe's portion of the transfer summary. QU_SF_TSF_MD_UN QuantityInteger integer

Relationships

Parent Entity Verb Phrase Child Entity
Safe contains StoreSafeTender
Tender is tracked through StoreSafeTender

Logical Views containing StoreSafeTender

Logical View
Logical 02510 - Tender Control Transaction - Movement View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03100 - Reporting - Store Operations - Macro View
Logical 03110 - Reporting - Store Operations - Tender Settlement
Logical 03160 - Reporting - Store Operations - Till View